Module Code: BM0245
Module Title: Information Management
Distributed on: Hand in Date:

Further information about general assessment criteria, ARNA regulations, referencing and plagiarism can be found on the module’s site on the e-Learning Portal. Students are advised to read and follow this information.

Instructions on Assessment:

Summative assessment of the module will be by a group assignment (50%) and an individual assignment (50%). Part A will be related to developing a prototype information system, which will be completed in groups. Part B will be an individual report of about 2,000 words. Details will be available under “Assignment” on the university’s eLearning Platform (Blackboard) during the latter part of the course.
PART A – Group Work (50 marks)

A Race Results system can help athletics/sports organisations to bring together their athletes, races and results details in one system to help them increase motivation, track performance and manage club operations. Collecting results from the competitions for each athlete has always been difficult to achieve due to the disparate systems used by the organising parties and bodies involved with athletics.

To date Athletics Club has been recording athlete information and race results in an Excel file (see document provided). When the organisation first started operating the Excel spreadsheet was adequate for their needs. However, as they continued growing the Excel file has become difficult to manage. It also does not allow the organisation to maintain records of race results in an effective and efficient manner.

Therefore, you are required to design a Race Results system using Microsoft Access 2010 which will:
• Manage athletes details more effectively by eliminating duplications and time wasting, and reducing the possibility for errors
• Provide all athlete and competition information in one place that is easily accessible and easy to use
• Find information about athletes’ performances/results through various queries/reports
• Ensure that athletes’ level of motivation is high by publishing race results
More specifically you will need to complete the following tasks:
Task Marks
1. Determine the requirements of the Race Results system requirements – record any assumptions that you may see necessary 3
2. Produce and describe a logical model of the information requirements – ERM (make sure you eliminate any duplicate data) 10
3. Build a Race Results system using Microsoft Access 2010 which encompasses the following functions:
a. Design all necessary tables and establish the relationships in Microsoft Access 2010 10
b. Create a report that counts the number of athletes who have competed 3
c. Count all the events entered by athletes in the month of October (group by race) 3
d. Create a summary report showing all the races/results that have been recorded for a specific athlete listed in chronological order 3
e. A list of all competing athletes who are not English Athletics (EA) registered (including their results information) 3
f. List all athletes who have joined the club in the last 10 years – show their best result/performance details (based on their race position) 3
g. For all North East Harrier League (NEHL) races show the details of the runners – additionally if they are considered a veteran runner (they are over 35 years old on the day of the race) 4
h. Design an attractive input screen for race results as well as input screens for athlete and race event details 8
Submission

You need to submit your answers to tasks 1 and 2 (including screenshots of queries, forms and reports designed) in the form of a written report with a maximum of 1,000 words. On USB/CD/DVD you submit your answers to task 3.

Peer Evaluation

As a part of your group assignment, please evaluate yourself as well as all your group members. On a scale of 0 to 10, please give every member a score (as 10 being the best). Your evaluations must be submitted through e-mail to your seminar/workshop tutor (subject line to be: BM0245 – Peer Evaluation) before noon on December 11, 2015. If you choose not to submit the form, it will be assumed that you evaluate all members equally and therefore all members receive the same mark for your group assignment.
The simple average of these evaluations will be used to create a weight, expressed as a proportion (a whole number ranging from 0 to 1). If the average of the evaluations given to you is 8/10, then, your weight becomes .8 and we apply this weight to the group mark to derive your final mark for the group part. If the group mark is 100/100, for example, and your weight is .8 then you will receive 80/100 for the group part of the assignment. Thus, it is important to contribute to the team.

PART B – Individual Report (50 marks)

You are required to act as a consultant for an organisation who has contracted you to provide your advice and recommendations on the choice and implementation of an information management system. The chosen area must be one covered in the module lectures and seminars this year e.g. BI, Enterprise IS, Social Media, E-business etc. You must present your findings to the organisation in the form of a 2000 word report, advising them on some of the potential choices and the key benefits for the organisation.
More specifically we will expect you to advise the organisation on the following aspects:

• System design versus System Acquisition
• Implementation issues involved
• Management of the IS change
• Global issues for consideration

You may choose the organisation that you do this work for, although you should discuss your choice with a tutor before starting your work. The organisation can be of any type and from any sector; public, private or voluntary, or an SME; and you may focus on a distinct area of the organisation if you so wish – such as sales, marketing, operations, strategic planning, disaster planning, command and control or other functional areas. You need to make this clear at the beginning of the report.

Your report must include critical evaluation of relevant theory to support the solutions you recommend and should therefore include reference to a wide range of sources, including academic journals and books, industry websites and white papers.

Word limits and penalties for assignments

If the assignment is within +10% of the stated word limit no penalty will apply.

The word count is to be declared on the front page of your assignment and the assignment cover sheet. The word count does not include:

• Title and Contents page • Reference list • Appendices • Appropriate tables, figures and illustrations
• Glossary • Bibliography • Quotes from interviews and focus groups.
Please note, in text citations [e.g. (Smith, 2011)] and direct secondary quotations [e.g. “dib-dab nonsense analysis” (Smith, 2011 p.123)] are INCLUDED in the word count.

If this word count is falsified, students are reminded that under ARNA page 30 Section 3.4 this will be regarded as academic misconduct.

If the word limit of the full assignment exceeds the +10% limit, 10% of the mark provisionally awarded to the assignment will be deducted. For example: if the assignment is worth 70 marks but is above the word limit by more than 10%, a penalty of 7 marks will be imposed, giving a final mark of 63.

Students are advised that they may be asked to submit an electronic version of their assignment.

Time limits and penalties for presentations

The time allocated for the presentation must be adhered to. At the end of this time, the presentation will be stopped and will be marked based on what has been delivered within the time limit.
Submission of Assessment:

All assignments must be submitted via the Undergraduate Programme Office. Each assignment must be accompanied by an Assessed Work Form which must be completed in full. The assignment will not be accepted by the Undergraduate Programme Office unless the form is completed correctly.

Marked assignments will be returned to students. It is advisable to retain a copy of your assignment for you own records. Your mark will be returned on the Assessed Work Form via the Undergraduate Programme Office.
Mapping to Programme Goals and Objectives:

This assessment will contribute directly to the following Undergraduate programme goals and objectives.

1. Knowledgeable about the theory and practice of international business and management
Objectives: Students will be able to:

X 1. Acquire knowledge of functional areas of business and management.

X 2. Acquire knowledge of specialist areas of business.

X 3. Apply their knowledge to business and management contexts.

X 4. Conduct contemporary research into business and management.
2. Skillful in the use of professional and managerial techniques and processes
Objectives: Students will be able to:

1. Provide evidence of self reflection as a means of informing personal development planning.

X 2. Demonstrate effective interpersonal communication skills and the ability to work in a team.

X 3. Demonstrate critical thinking skills .

X 4. Demonstrate problem solving skills.
3. Aware of ethical issues impacting on business and professional practice
Objectives: Students will be able to:

1. Identify an ethical dilemma in a business situation
2. Suggest ethical solutions to this dilemma

4. Employable as graduates
Objectives: Students will be able to:

X 1. In the context of securing graduate employment demonstrate the skills of self presentation.

Assessment Criteria (NBS)

Module Specific Assessment Criteria – Part A

Trait 0 – 29 30 – 39 40 – 49 50 – 59 60 – 69 70 – 79 80 – 100
Knowledge and Understanding A very poor documentation of the database design. A very poorly designed user interface. A very poor implementation of the user requirements. A poor documentation of the database design. A poorly designed user interface. A poor implementation of the user requirements. A less than adequate documentation of the database design. An inadequately designed user interface. An inadequate implementation of the user requirements. A good documentation of the database design. A good designed user interface. A good implementation of the user requirements. A very good documentation of the database design. A very good designed user interface. A very good implementation of the user requirements. An impressive documentation of the database design. An impressively designed user interface. An impressive implementation of the user requirements. An excellent documentation of the database design. An excellent designed user interface. An excellent implementation of the user requirements.
Structure and Alignment Very poor structure and any arguments are unclear and incomprehensible. The database does not address the systems requirements. Poor structure while most arguments are inappropriate. The database is more often than not addressing the systems requirements. The work contains some legitimate structure but is poorly set out. The database addresses very basic concepts in an unsophisticated manner. The analysis is clear although it lacks focus at places. The database addresses most of the requirements but often in an unsophisticated manner. The structure and analysis is relevant, generally well-focused and organised. The database is well designed and addresses the system requirements set. The structure and analysis is relevant and well sustained. The database is very well designed in a sophisticated manner. The structure and analysis is excellent. The database is designed in an excellent and sophisticated manner and it shows consideration of all the principles outlined regarding the system requirements.
Module Specific Assessment Criteria – Part B

Trait 0 – 29 30 – 39 40 – 49 50 – 59 60 – 69 70 – 79 80 – 100
Knowledge and Understanding A very poor introduction to the report. A very poor literature review of the academic material, using a very poor range of sources. A very poor discussion and a summary of managerial challenges. A poor introduction to the report. A poor literature review of the academic material, using very limited sources. Unclear discussion and a poor summary of managerial challenges. A less than adequate introduction to the report. An inadequate literature review of the academic material, using limited sources. Heavily descriptive discussion and an uncritical summary of managerial challenges. A good introduction to the report. A good literature review of the academic material, using good sources. Good discussion with a sound summary of managerial challenges. A very good introduction to the report. A very good literature review of the academic material, using good sources. Very good discussion with a sound summary of managerial challenges. An impressive introduction to the report. An impressive literature review of the academic material, using very good sources. An impressive discussion with an impressive summary of managerial challenges. An excellent introduction to the report. An excellent literature review of the academic material, using very good sources. An excellent discussion with an excellent summary of managerial challenges.
Structure and Alignment Very poor structure and any arguments are unclear and incomprehensible. The report does not address the requirements. Poor structure while most arguments are inappropriate. The report is more often than not addressing the requirements. The work contains some legitimate structure but is poorly set out. The report addresses very basic concepts in an unsophisticated manner. The analysis is clear although it lacks focus at places. The report addresses most of the requirements but often in an unsophisticated manner. The structure and analysis is relevant, generally well-focused and organised. The report is well designed and addresses the requirements set. The structure and analysis is relevant and well sustained. The report is very well designed in a sophisticated manner. The structure and analysis is excellent. The report is designed in an excellent and sophisticated manner and it shows consideration of all the principles outlined regarding the requirements.

Note: For those assessments or partial assessments based on calculation, multiple choice etc. marks will be gained on an accumulative basis. In these cases, marks allocated to each section will be made clear.

Students must retain an electronic copy of this assignment and it must be made available within 24 hours of them requesting it be submitted.

Module Code: BM0245
Module Title: Information Management
Distributed on: Hand in Date:

Further information about general assessment criteria, ARNA regulations, referencing and plagiarism can be found on the module’s site on the e-Learning Portal. Students are advised to read and follow this information.

Instructions on Assessment:

Summative assessment of the module will be by a group assignment (50%) and an individual assignment (50%). Part A will be related to developing a prototype information system, which will be completed in groups. Part B will be an individual report of about 2,000 words. Details will be available under “Assignment” on the university’s eLearning Platform (Blackboard) during the latter part of the course.
PART A – Group Work (50 marks)

A Race Results system can help athletics/sports organisations to bring together their athletes, races and results details in one system to help them increase motivation, track performance and manage club operations. Collecting results from the competitions for each athlete has always been difficult to achieve due to the disparate systems used by the organising parties and bodies involved with athletics.

To date Athletics Club has been recording athlete information and race results in an Excel file (see document provided). When the organisation first started operating the Excel spreadsheet was adequate for their needs. However, as they continued growing the Excel file has become difficult to manage. It also does not allow the organisation to maintain records of race results in an effective and efficient manner.

Therefore, you are required to design a Race Results system using Microsoft Access 2010 which will:
• Manage athletes details more effectively by eliminating duplications and time wasting, and reducing the possibility for errors
• Provide all athlete and competition information in one place that is easily accessible and easy to use
• Find information about athletes’ performances/results through various queries/reports
• Ensure that athletes’ level of motivation is high by publishing race results
More specifically you will need to complete the following tasks:
Task Marks
1. Determine the requirements of the Race Results system requirements – record any assumptions that you may see necessary 3
2. Produce and describe a logical model of the information requirements – ERM (make sure you eliminate any duplicate data) 10
3. Build a Race Results system using Microsoft Access 2010 which encompasses the following functions:
a. Design all necessary tables and establish the relationships in Microsoft Access 2010 10
b. Create a report that counts the number of athletes who have competed 3
c. Count all the events entered by athletes in the month of October (group by race) 3
d. Create a summary report showing all the races/results that have been recorded for a specific athlete listed in chronological order 3
e. A list of all competing athletes who are not English Athletics (EA) registered (including their results information) 3
f. List all athletes who have joined the club in the last 10 years – show their best result/performance details (based on their race position) 3
g. For all North East Harrier League (NEHL) races show the details of the runners – additionally if they are considered a veteran runner (they are over 35 years old on the day of the race) 4
h. Design an attractive input screen for race results as well as input screens for athlete and race event details 8
Submission

You need to submit your answers to tasks 1 and 2 (including screenshots of queries, forms and reports designed) in the form of a written report with a maximum of 1,000 words. On USB/CD/DVD you submit your answers to task 3.

Peer Evaluation

As a part of your group assignment, please evaluate yourself as well as all your group members. On a scale of 0 to 10, please give every member a score (as 10 being the best). Your evaluations must be submitted through e-mail to your seminar/workshop tutor (subject line to be: BM0245 – Peer Evaluation) before noon on December 11, 2015. If you choose not to submit the form, it will be assumed that you evaluate all members equally and therefore all members receive the same mark for your group assignment.
The simple average of these evaluations will be used to create a weight, expressed as a proportion (a whole number ranging from 0 to 1). If the average of the evaluations given to you is 8/10, then, your weight becomes .8 and we apply this weight to the group mark to derive your final mark for the group part. If the group mark is 100/100, for example, and your weight is .8 then you will receive 80/100 for the group part of the assignment. Thus, it is important to contribute to the team.

PART B – Individual Report (50 marks)

You are required to act as a consultant for an organisation who has contracted you to provide your advice and recommendations on the choice and implementation of an information management system. The chosen area must be one covered in the module lectures and seminars this year e.g. BI, Enterprise IS, Social Media, E-business etc. You must present your findings to the organisation in the form of a 2000 word report, advising them on some of the potential choices and the key benefits for the organisation.
More specifically we will expect you to advise the organisation on the following aspects:

• System design versus System Acquisition
• Implementation issues involved
• Management of the IS change
• Global issues for consideration

You may choose the organisation that you do this work for, although you should discuss your choice with a tutor before starting your work. The organisation can be of any type and from any sector; public, private or voluntary, or an SME; and you may focus on a distinct area of the organisation if you so wish – such as sales, marketing, operations, strategic planning, disaster planning, command and control or other functional areas. You need to make this clear at the beginning of the report.

Your report must include critical evaluation of relevant theory to support the solutions you recommend and should therefore include reference to a wide range of sources, including academic journals and books, industry websites and white papers.

Word limits and penalties for assignments

If the assignment is within +10% of the stated word limit no penalty will apply.

The word count is to be declared on the front page of your assignment and the assignment cover sheet. The word count does not include:

• Title and Contents page • Reference list • Appendices • Appropriate tables, figures and illustrations
• Glossary • Bibliography • Quotes from interviews and focus groups.
Please note, in text citations [e.g. (Smith, 2011)] and direct secondary quotations [e.g. “dib-dab nonsense analysis” (Smith, 2011 p.123)] are INCLUDED in the word count.

If this word count is falsified, students are reminded that under ARNA page 30 Section 3.4 this will be regarded as academic misconduct.

If the word limit of the full assignment exceeds the +10% limit, 10% of the mark provisionally awarded to the assignment will be deducted. For example: if the assignment is worth 70 marks but is above the word limit by more than 10%, a penalty of 7 marks will be imposed, giving a final mark of 63.

Students are advised that they may be asked to submit an electronic version of their assignment.

Time limits and penalties for presentations

The time allocated for the presentation must be adhered to. At the end of this time, the presentation will be stopped and will be marked based on what has been delivered within the time limit.
Submission of Assessment:

All assignments must be submitted via the Undergraduate Programme Office. Each assignment must be accompanied by an Assessed Work Form which must be completed in full. The assignment will not be accepted by the Undergraduate Programme Office unless the form is completed correctly.

Marked assignments will be returned to students. It is advisable to retain a copy of your assignment for you own records. Your mark will be returned on the Assessed Work Form via the Undergraduate Programme Office.
Mapping to Programme Goals and Objectives:

This assessment will contribute directly to the following Undergraduate programme goals and objectives.

1. Knowledgeable about the theory and practice of international business and management
Objectives: Students will be able to:

X 1. Acquire knowledge of functional areas of business and management.

X 2. Acquire knowledge of specialist areas of business.

X 3. Apply their knowledge to business and management contexts.

X 4. Conduct contemporary research into business and management.
2. Skillful in the use of professional and managerial techniques and processes
Objectives: Students will be able to:

1. Provide evidence of self reflection as a means of informing personal development planning.

X 2. Demonstrate effective interpersonal communication skills and the ability to work in a team.

X 3. Demonstrate critical thinking skills .

X 4. Demonstrate problem solving skills.
3. Aware of ethical issues impacting on business and professional practice
Objectives: Students will be able to:

1. Identify an ethical dilemma in a business situation
2. Suggest ethical solutions to this dilemma

4. Employable as graduates
Objectives: Students will be able to:

X 1. In the context of securing graduate employment demonstrate the skills of self presentation.

Assessment Criteria (NBS)

Module Specific Assessment Criteria – Part A

Trait 0 – 29 30 – 39 40 – 49 50 – 59 60 – 69 70 – 79 80 – 100
Knowledge and Understanding A very poor documentation of the database design. A very poorly designed user interface. A very poor implementation of the user requirements. A poor documentation of the database design. A poorly designed user interface. A poor implementation of the user requirements. A less than adequate documentation of the database design. An inadequately designed user interface. An inadequate implementation of the user requirements. A good documentation of the database design. A good designed user interface. A good implementation of the user requirements. A very good documentation of the database design. A very good designed user interface. A very good implementation of the user requirements. An impressive documentation of the database design. An impressively designed user interface. An impressive implementation of the user requirements. An excellent documentation of the database design. An excellent designed user interface. An excellent implementation of the user requirements.
Structure and Alignment Very poor structure and any arguments are unclear and incomprehensible. The database does not address the systems requirements. Poor structure while most arguments are inappropriate. The database is more often than not addressing the systems requirements. The work contains some legitimate structure but is poorly set out. The database addresses very basic concepts in an unsophisticated manner. The analysis is clear although it lacks focus at places. The database addresses most of the requirements but often in an unsophisticated manner. The structure and analysis is relevant, generally well-focused and organised. The database is well designed and addresses the system requirements set. The structure and analysis is relevant and well sustained. The database is very well designed in a sophisticated manner. The structure and analysis is excellent. The database is designed in an excellent and sophisticated manner and it shows consideration of all the principles outlined regarding the system requirements.
Module Specific Assessment Criteria – Part B

Trait 0 – 29 30 – 39 40 – 49 50 – 59 60 – 69 70 – 79 80 – 100
Knowledge and Understanding A very poor introduction to the report. A very poor literature review of the academic material, using a very poor range of sources. A very poor discussion and a summary of managerial challenges. A poor introduction to the report. A poor literature review of the academic material, using very limited sources. Unclear discussion and a poor summary of managerial challenges. A less than adequate introduction to the report. An inadequate literature review of the academic material, using limited sources. Heavily descriptive discussion and an uncritical summary of managerial challenges. A good introduction to the report. A good literature review of the academic material, using good sources. Good discussion with a sound summary of managerial challenges. A very good introduction to the report. A very good literature review of the academic material, using good sources. Very good discussion with a sound summary of managerial challenges. An impressive introduction to the report. An impressive literature review of the academic material, using very good sources. An impressive discussion with an impressive summary of managerial challenges. An excellent introduction to the report. An excellent literature review of the academic material, using very good sources. An excellent discussion with an excellent summary of managerial challenges.
Structure and Alignment Very poor structure and any arguments are unclear and incomprehensible. The report does not address the requirements. Poor structure while most arguments are inappropriate. The report is more often than not addressing the requirements. The work contains some legitimate structure but is poorly set out. The report addresses very basic concepts in an unsophisticated manner. The analysis is clear although it lacks focus at places. The report addresses most of the requirements but often in an unsophisticated manner. The structure and analysis is relevant, generally well-focused and organised. The report is well designed and addresses the requirements set. The structure and analysis is relevant and well sustained. The report is very well designed in a sophisticated manner. The structure and analysis is excellent. The report is designed in an excellent and sophisticated manner and it shows consideration of all the principles outlined regarding the requirements.

Note: For those assessments or partial assessments based on calculation, multiple choice etc. marks will be gained on an accumulative basis. In these cases, marks allocated to each section will be made clear.

Students must retain an electronic copy of this assignment and it must be made available within 24 hours of them requesting it be submitted.